Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11055 | 11055 | 50.130.83b | 0 | 1 | 12064 | American Paintings and Sculpture 2 | Watercolor 198 | Portrait of a Man | Artist|Artist 13 | After | John Singer Sargent|Rembrandt (Rembrandt van Rijn) | American, Florence 1856–1925 London|Dutch, Leiden 1606–1669 Amsterdam | Sargent, John Singer|Rembrandt (Rembrandt van Rijn) 1743 | American|Dutch 50 | 1856 |1606 | 1925 |1669 | ca. 1865–68 | 1865 | 1868 | Watercolor and graphite on off-white wove paper 1416 | 14 3/4 x 11 7/8 in. (37.5 x 30.2 cm) | Gift of Mrs. Francis Ormond, 1950 | Drawings 9 | http://www.metmuseum.org/art/collection/search/12064 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
252655 | 252655 | 54.90.1145 | 0 | 0 | 381159 | Drawings and Prints 11 | Print 731 | Niew Amsterdam, from Dr. Adrien Van der Dunk's Map of 1656 | Artist|Artist 13 | After | Anonymous, American, 19th century|Adriaen van der Donck | Dutch, 1620–1655 | Anonymous, American, 19th century|Donck, Adriaen van der 35967 | American|Dutch 50 | 1800 |1620 | 1900 |1655 | 19th century | 1800 | 1900 | Etching and engraving 6712 | plate: 4 15/16 x 8 1/4 in. (12.5 x 21 cm) sheet: 8 7/8 x 11 1/8 in. (22.6 x 28.2 cm) | The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954 | Prints 13 | http://www.metmuseum.org/art/collection/search/381159 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
265544 | 265544 | 54.90.1388 | 0 | 0 | 394511 | Drawings and Prints 11 | Print 731 | New Amsterdam now New York, As it Appeared about the Year 1640 while under the Dutch Government | Publisher|Artist 740 | Printed and published by|After | Henry R. Robinson|Justus Danckerts | American, active ca. 1830/33–1850|Dutch, Amsterdam 1635–1701 Amsterdam | Robinson, Henry R.|Danckerts, Justus 38953 | American|Dutch 50 | 1830 |1635 | 1850 |1701 | 1836–42 | 1836 | 1842 | Lithograph 14948 | sheet: 10 11/16 x 14 5/16 in. (27.2 x 36.4 cm) | The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954 | Prints 13 | http://www.metmuseum.org/art/collection/search/394511 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
302454 | 302454 | 66.582.8 | 0 | 0 | 432241 | Drawings and Prints 11 | Print 731 | The Jolly Man | Artist|Artist 13 | Engraved by|After | Timothy Cole|Frans Hals | American, London 1852–1931 Poughkeepsie, New York|Dutch, Antwerp 1582/83–1666 Haarlem | Cole, Timothy|Hals, Frans 43117 | American|Dutch 50 | 1852 |1582 | 1852 |1666 | 1893 | 1893 | 1893 | Wood engraving 29001 | Image: 6 1/16 × 5 3/16 in. (15.4 × 13.2 cm) Sheet: 11 3/4 × 9 1/2 in. (29.9 × 24.2 cm) | Gift of Mrs. Fred Bonar Wright, 1966 | Prints 13 | http://www.metmuseum.org/art/collection/search/432241 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
302456 | 302456 | 66.582.10 | 0 | 0 | 432243 | Drawings and Prints 11 | Print 731 | Portrait of a Man | Artist|Artist 13 | Engraved by|After | Timothy Cole|Ferdinand Bol | American, London 1852–1931 Poughkeepsie, New York|Dutch, Dordrecht 1616–1680 Amsterdam | Cole, Timothy|Bol, Ferdinand 43118 | American|Dutch 50 | 1852 |1616 | 1852 |1680 | 1894 | 1894 | 1894 | Wood engraving 29001 | Image: 6 7/16 × 5 1/4 in. (16.3 × 13.4 cm) Sheet: 11 15/16 × 9 5/8 in. (30.4 × 24.4 cm) | Gift of Mrs. Fred Bonar Wright, 1966 | Prints 13 | http://www.metmuseum.org/art/collection/search/432243 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
302461 | 302461 | 50.579.2 | 0 | 0 | 432248 | Drawings and Prints 11 | Print 731 | Philemon and Baucis | Artist|Artist 13 | Engraved by|After | Timothy Cole|Rembrandt (Rembrandt van Rijn) | American, London 1852–1931 Poughkeepsie, New York|Dutch, Leiden 1606–1669 Amsterdam | Cole, Timothy|Rembrandt (Rembrandt van Rijn) 43121 | American|Dutch 50 | 1852 |1606 | 1852 |1669 | 1927 | 1927 | 1927 | Wood engraving 29001 | Image: 5 3/8 × 7 1/16 in. (13.7 × 18 cm) Sheet: 10 5/8 × 12 13/16 in. (27 × 32.5 cm) | Gift of Miss Alberte Welch, 1950 | Prints 13 | http://www.metmuseum.org/art/collection/search/432248 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
302465 | 302465 | 50.579.1 | 0 | 0 | 432252 | Drawings and Prints 11 | Print 731 | Portrait of Rembrandt van Rijn | Artist|Artist 13 | Engraved by|After | Timothy Cole|Rembrandt (Rembrandt van Rijn) | American, London 1852–1931 Poughkeepsie, New York|Dutch, Leiden 1606–1669 Amsterdam | Cole, Timothy|Rembrandt (Rembrandt van Rijn) 43121 | American|Dutch 50 | 1852 |1606 | 1852 |1669 | 1921 | 1921 | 1921 | Wood engraving 29001 | Image: 9 11/16 × 7 15/16 in. (24.6 × 20.1 cm) Sheet: 13 3/4 × 10 13/16 in. (35 × 27.5 cm) | Gift of Miss Alberte Welch, 1950 | Prints 13 | http://www.metmuseum.org/art/collection/search/432252 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
302511 | 302511 | 25.78.656 | 0 | 0 | 432305 | Drawings and Prints 11 | Print 731 | L'Offre Galante (Feast of Saint Nicholas) | Artist|Publisher|Artist 867 | Engraved by|After | Timothy Cole|Scribner's Monthly|Jan Havickszoon Steen | American, London 1852–1931 Poughkeepsie, New York|Dutch, 1626–1679 | Cole, Timothy|Scribner's Monthly|Steen, Jan Havickszoon 43130 | American|Dutch 50 | 1852 |1870 |1626 | 1852 |1881 |1679 | 1893 | 1893 | 1893 | Wood engraving 29001 | Image: 5 13/16 × 4 3/4 in. (14.8 × 12 cm) Sheet: 6 13/16 × 5 1/8 in. (17.3 × 13 cm) | Anonymous Gift, 1925 | Prints 13 | http://www.metmuseum.org/art/collection/search/432305 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
335550 | 335550 | 1984.217.10 | 0 | 0 | 483052 | Modern and Contemporary Art 4 | Port glass 7692 | "Narciso" Port Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 6-3/4, D(1). 2-3/8, D(2). 2-7/8 inches (17.1 x 6 x 7.3 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483052 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335551 | 335551 | 1984.217.11 | 0 | 0 | 483053 | Modern and Contemporary Art 4 | Cognac snifter 15157 | "Narciso" Cognac Snifter | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 7-3/8, D(1). 2-1/2, D(2) 3-3/8 in. (18.7 x 6.4 x 8.6 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483053 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335552 | 335552 | 1984.217.12 | 0 | 0 | 483054 | Modern and Contemporary Art 4 | Parfait glass 676 | "Narciso" Parfait Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 7, D(1). 2-5/8, D(2). 3-3/4 in. (17.8 x 6.7 x 9.5 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483054 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335553 | 335553 | 1984.217.13 | 0 | 0 | 483055 | Modern and Contemporary Art 4 | Whiskey or gin glass 15158 | "Narciso" Whiskey or Gin Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 6-7/8, D(1). 1-3/4, D(2). 2-1/8 inches (17.5 x 4.4 x 5.4 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483055 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335554 | 335554 | 1984.217.14 | 0 | 0 | 483056 | Modern and Contemporary Art 4 | Champagne glass 206 | "Narciso" Champagne Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 7, D(1). 1-7/8, D(2). 5-1/2 inches (17.8 x 4.8 x 14 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483056 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335555 | 335555 | 1984.217.1ab | 0 | 0 | 483057 | Modern and Contemporary Art 4 | Decanter with lid 15159 | "Narciso" Decanter with Lid | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | Overall (with lid): H. 15-3/4, D. (Base) 4-1/4 in. (40 x 10.8 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483057 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335556 | 335556 | 1984.217.2 | 0 | 0 | 483058 | Modern and Contemporary Art 4 | Liqueur glass 7765 | "Narciso" Liqueur Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 6-3/4 in. (17.1 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483058 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335557 | 335557 | 1984.217.3 | 0 | 0 | 483059 | Modern and Contemporary Art 4 | Sherry glass 798 | "Narciso" Sherry Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 7, D(1). 1-3/4, D(2). 2-5/8 inches (17.8 x 4.4 x 6.7 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483059 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335558 | 335558 | 1984.217.4 | 0 | 0 | 483060 | Modern and Contemporary Art 4 | Beer glass 15160 | "Narciso" Beer Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 7-7/8, D(1). 3, D(2). 2-1/2 inches (20 x 7.7 x 6.4 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483060 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335559 | 335559 | 1984.217.5 | 0 | 0 | 483061 | Modern and Contemporary Art 4 | Ice tea glass 15161 | "Narciso" Iced Tea Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 9-3/4, D(1). 2-1/2, D(2). 2-1/2 in. (24.8 x 6.4 x 6.4 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483061 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335560 | 335560 | 1984.217.6 | 0 | 0 | 483062 | Modern and Contemporary Art 4 | Tom Collins glass 15162 | "Narciso" Tom Collins Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 10-1/8, D(1). 2, D(2) 2-1/8 inches (25.7 x 5.1 x 5.4 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483062 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335561 | 335561 | 1984.217.7 | 0 | 0 | 483063 | Modern and Contemporary Art 4 | Wine glass 978 | "Narciso" Wine Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 7-5/8, D(1). 2-1/4, D(2). 2-5/8 in. (19.4 x 5.7 x 6.7 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483063 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335562 | 335562 | 1984.217.8 | 0 | 0 | 483064 | Modern and Contemporary Art 4 | Wine glass 978 | "Narciso" Wine Glass | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 6-1/2, D(1). 2-1/2, D(2). 2-7/8 inches (16.5 x 6.4 7.3 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483064 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
335563 | 335563 | 1984.217.9 | 0 | 0 | 483065 | Modern and Contemporary Art 4 | Champagne flute 1271 | "Narciso" Champagne Flute | Designer|Manufacturer 3 | Isabel Giampietro Knoll|Royal Leerdam Glass | American (born Italy), Marsicovetere 1917–2010 New York|Dutch | Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 | American|Dutch 50 | 1917 | 2010 | 1956 | 1956 | 1956 | Glass 31 | H. 9-1/8, D(1). 2-1/4, D(2). 2-3/8 inches (23.2 x 5.7 x 6 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984 | Glass 3 | http://www.metmuseum.org/art/collection/search/483065 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");